Hệ thống quản lý trường đại học bằng PHP
1 <?php require('../includes/config.php'); ?>
2 <!DOCTYPE HTML>
3 <html>
4 <head>
5 <title>Institut national des sciences appliquées et de technologie</title>
6 <meta charset="utf-8" />
7 <meta http-equiv="X-UA-Compatible" content="IE=edge">
8 <meta name="viewport" content="width=device-width, initial-scale=1">
9 <link href="../assets/css/bootstrap.css" rel="stylesheet">
10 <link rel="stylesheet" href="../assets/css/main.css" />
11 <link href="../assets/css/simple-sidebar.css" rel="stylesheet">
12 </head>
13 <body title="member">
14 <?php require('../includes/header.php'); ?>
15 <div id="wrapper">
16 <!-- Sidebar -->
17 <div id="sidebar-wrapper">
18 <ul class="sidebar-nav">
19 <li class="sidebar-brand">
20 <a href="../index_member.php">
21 Espace Membre
22 </a>
23 </li>
24 <li>
25 <a href="filiereSelec.php?type=C">Cours</a>
26 </li>
27 <li>
28 <a href="filiereSelec.php?type=AD">Anciens Devoirs</a>
29 </li>
30 <li>
31 <a href="filiereSelec.php?type=E">Exercices</a>
32 </li>
33 <li>
34 <a href="filiereSelec.php?type=R">Résultats</a>
35 </li>
36 </ul>
37 </div>
38 <!-- /#sidebar-wrapper -->
39 <!-- Page Content -->
40 <div id="page-content-wrapper">
41 <div class="container-fluid">
42 <div class="row">
43 <div class="col-lg-12">
44 <h1>Matiere</h1>
45 </div>
46 <?php
47 $filiere = $_GET['lvlID'];
48 $type = $_GET['type'];
49 $stmt = $db->prepare('SELECT * FROM Matiere INNER JOIN MatiereParFiliere
50 ON Matiere.matiereID = MatiereParFiliere.matiereID
51 WHERE MatiereParFiliere.lvlID= :lvlID ');
52 $stmt->execute(array(':lvlID' => $filiere));
53 while($row = $stmt->fetch()){
54 ?>
55 <div class="col-lg-3 col-md-6">
56 <div class="panel panel-primary">
57 <div class="panel-heading">
58 <div class="row">
59 <div class="col-xs-3">
60 <?php
61 $req_count_res = $db->prepare('SELECT COUNT(*) FROM Note
62 WHERE Note.matiereID = :matiereID
63 AND Note.lvlID = :lvlID
64 ');
65 $req_count_res->execute(array(':matiereID'=> $row['matiereID'] , ':lvlID' => $filiere));
66 $num_res = $req_count_res->fetch();
67 $res_count=$num_res[0];
68 $req_count = $db->prepare('SELECT COUNT(*) FROM Documents
69 WHERE Documents.matiereID = :matiereID
70 AND Documents.lvlID = :lvlID
71 AND Documents.type = :type
72 ');
73 $req_count->execute(array(':matiereID'=> $row['matiereID'] , ':lvlID' => $filiere,
74 ':type' => $type));
75 $num = $req_count->fetch();
76 $doc_number=$num[0];
77 if ($_GET['type']=="R"){
78 if ($res_count==0)
79 echo '<i class="fa fa-folder fa-4x"></i>';
80 else echo '<i class="fa fa-folder-open fa-4x"></i>';
81 }
82 else { if ($doc_number==0)
83 echo '<i class="fa fa-folder fa-4x"></i>';
84 else echo '<i class="fa fa-folder-open fa-4x"></i>';
85 }
86 ?>
87 </div>
88 <div class="col-xs-9 text-right">
89 <?php echo '<div>'.$row['nom'].'</div>' ?>
90 </div>
91 </div>
92 </div>
93 <a <?php
94 if ($_GET['type']=="R"){
95 if ($res_count==0)
96 echo 'onclick="myFunction2()"';
97 else echo 'href="resultsview.php?type='.$_GET['type'].'&lvlID='.$row['lvlID'].'&matiereID='.$row['matiereID'].'"';
98 }
99 else{if ($doc_number==0)
100 echo 'onclick="myFunction()"';
101 else echo 'href="documentsview.php?type='.$_GET['type'].'&lvlID='.$row['lvlID'].'&matiereID='.$row['matiereID'].'"';} ?>>
102 <div class="panel-footer">
103 <span class="pull-left">Visit</span>
104 <span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
105 <div class="clearfix"></div>
106 </div>
107 </a>
108 </div>
109 </div>
110
111 <?php
112 }
113 ?>
114 </div>
115 </div>
116 </div>
117 <!-- /#page-content-wrapper -->
118 </div>
119 <!-- /#wrapper -->
120 <!-- jQuery -->
121 <script src="../assets/js/jquery.js"></script>
122 <!-- Bootstrap Core JavaScript -->
123 <script src="../assets/js/bootstrap.min.js"></script>
124 <!-- Menu Toggle Script -->
125 <script src="../assets/js/jquery.min.js"></script>
126 <script src="../assets/js/skel.min.js"></script>
127 <script src="../assets/js/util.js"></script>
128 <!--[if lte IE 8]><script src="assets/js/ie/respond.min.js"></script><![endif]-->
129 <script src="../assets/js/main.js"></script>
130
131 <script>
132 function myFunction() {
133 alert("Sorry no documents for the moment");
134 }
135 </script>
136 <script>
137 function myFunction2() {
138 alert("Sorry no Results have been added yet");
139 }
140 </script>
141 </body>
142 </html>